Example: Join Timestamps

A new dataset will be created by joining all the timestamps into a new timestamp field, listing all the timestamps in chronological order. All original data values are included in the new dataset, and will still correspond to the original timestamp to which they were mapped. Additional timestamps will be filled by either repeating the last known value, or interpolating the value.

Initial dataset:

Configuration:

Selected Fields: Field1 and Field2

Selected Timestamp: Field7 and Field8

Interpolate Values: Yes

Created Output:

    • Field1_Field7

    • Field1_Field8

    • Field2_Field7

    • Field2_Field8

Resulting dataset:

Note that the values at the start of each field will still be null, even though interpolate values was selected. The reason for this is because the are no "first" values to use for interpolation.


Related topics:

  

CSense 2023- Last updated: June 24,2025